/**
 
 This file is part of clibudget - a tool to manage your budgets from the
 command-line.

 Hardcoded query values and file location strings are defined in this file to
 be used throughout the program under a common context.

 Copyright 2022 - kzimmermann 

 This program is Free Software licensed under the terms and conditions of the
 GNU GPL v3. For more information, see https://www.gnu.org/licenses

*/

#include <stdlib.h>

#ifndef _DATA_H
#define _DATA_H

// ---- QUERIES ----
// The following are the queries that operate the "meat" of the program:

#define QUERY_INSERT "INSERT INTO expenses (category, day, cost, description) VALUES ('%s','%s', %d, '%s')"

#define QUERY_ANALYZE "SELECT category, SUM(cost) AS total FROM expenses GROUP BY category"

#define QUERY_BUDGET_PERC "SELECT SUM(cost) AS total FROM expenses"

// ---- /QUERIES ----

// ---- FILES ----
// Here we define where the location of the program's data / config files 

#define CONFIG_DIR ".config/clibudget"
#define CONFIG_FILE "config"
#define CONFIG_DB "budget.db"

// ---- /FILES ----

#endif
